{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":49,"n_cols":35,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,14,3,18],[5,1,5,2],[12,13,16,13],[19,2,19,3],[8,13,8,14],[8,8,8,9],[8,3,8,4],[8,1,8,2],[19,18,19,19],[19,14,19,15],[6,1,6,2],[8,5,8,7],[9,1,9,19],[6,8,6,9],[6,3,6,7],[10,2,10,3],[47,1,47,19],[28,2,28,3],[28,6,28,7],[8,18,8,19],[10,6,10,7],[10,10,10,11],[10,14,10,15],[10,18,10,19],[19,10,19,11],[19,6,19,7],[28,14,28,15],[51,1,51,3],[54,1,54,2],[28,18,28,19],[37,18,37,19],[37,14,37,15],[37,10,37,11],[39,1,43,1],[39,5,43,5],[56,1,56,3],[56,7,56,10],[37,6,37,7],[37,2,37,3],[28,10,28,11],[48,2,48,19],[30,1,34,1],[30,13,34,13],[30,17,34,17],[30,5,34,5],[30,9,34,9],[56,15,56,17],[39,17,43,17],[46,1,46,19],[39,9,43,9],[39,13,43,13],[0,1,0,19],[21,5,25,5],[21,9,25,9],[21,13,25,13],[21,17,25,17],[12,17,16,17],[21,1,25,1],[12,1,16,1],[12,5,16,5],[12,9,16,9],[1,1,1,19],[8,15,8,17],[3,1,3,2],[5,11,5,18],[3,8,3,9],[3,3,3,7]]}
[null,"G.S.M.H.L.Consolidated Sheet"]
[null,"Fill in this box Completely Every Match !!"]
[null,null,null,null,null,null,null,null,"Final Score"]
[null,"Your Team Name:"]
[]
[null,"V.S.",null,null,null,null,null,null,"Final Score",null,null,"Place a check or an X in the correct box"]
[null,"Opponent:",null,null,null,null,null,null,null,null,null,null,"Out Div",null,null,null,"In Div"]
[]
[null,"Games Played",null,{"$f":"SUM(B18,F18,J18,N18,R18,B27,F27,J27,N27,R27,B36,F36,J36,N36,R36,B45,F45,J45,N45,R45)","v":0},null,"Total Shoes: ",null,null,{"$f":"IF(SUM(C18,G18,K18,O18,S18,S27,O27,K27,G27,C27,C36,G36,K36,O36,S36,S45,O45,K45,G45,C45)<=0,\"\",SUM(C18,G18,K18,O18,S18,S27,O27,K27,G27,C27,C36,G36,K36,O36,S36,S45,O45,K45,G45,C45))","v":""},null,null,null,"Total Ringers: ",{"$f":"IF(SUM(D18,H18,L18,P18,T18,T27,P27,L27,H27,D27,D36,H36,L36,P36,T36,T45,P45,L45,H45,D45)=0,\"\",SUM(D18,H18,L18,P18,T18,T27,P27,L27,H27,D27,D36,H36,L36,P36,T36,T45,P45,L45,H45,D45))","v":""},null,"Total Match % (optional)",null,null,{"$f":"IF(ISERROR(N9/I9),\"\",N9/I9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Do Not Copy totals from the master sheet, use this sheet to add total shoes and ringers, then compare with master!"]
[null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5]
[null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings"]
[null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played"]
[]
[]
[]
[]
[null,{"$f":"IF(COUNT(C13:C17)=0,\"\",COUNT(C13:C17))","v":""},{"$f":"IF(SUM(C13:C17)<=0,\"\",SUM(C13:C17))","v":""},{"$f":"IF(SUM(D13:D17)<=0,\"\",SUM(D13:D17))","v":""},null,{"$f":"IF(COUNT(G13:G17)=0,\"\",COUNT(G13:G17))","v":""},{"$f":"IF(SUM(G13:G17)<=0,\"\",SUM(G13:G17))","v":""},{"$f":"IF(SUM(H13:H17)<=0,\"\",SUM(H13:H17))","v":""},null,{"$f":"IF(COUNT(K13:K17)=0,\"\",COUNT(K13:K17))","v":""},{"$f":"IF(SUM(K13:K17)<=0,\"\",SUM(K13:K17))","v":""},{"$f":"IF(SUM(L13:L17)<=0,\"\",SUM(L13:L17))","v":""},null,{"$f":"IF(COUNT(O13:O17)=0,\"\",COUNT(O13:O17))","v":""},{"$f":"IF(SUMIF(O13:O17,\">=0\")<=0,\"\",SUMIF(O13:O17,\">=0\"))","v":""},{"$f":"IF(SUM(P13:P17)<=0,\"\",SUM(P13:P17))","v":""},null,{"$f":"IF(COUNT(S13:S17)=0,\"\",COUNT(S13:S17))","v":""},{"$f":"IF(SUM(S13:S17)<=0,\"\",SUM(S13:S17))","v":""},{"$f":"IF(SUM(T13:T17)<=0,\"\",SUM(T13:T17))","v":""}]
[null,null,"%",{"$f":"IF(ISERROR(D18/C18),\"\",D18/C18)","v":""},null,null,"%",{"$f":"IF(ISERROR(H18/G18),\"\",H18/G18)","v":""},null,null,"%",{"$f":"IF(ISERROR(L18/K18),\"\",L18/K18)","v":""},null,null,"%",{"$f":"IF(ISERROR(P18/O18),\"\",P18/O18)","v":""},null,null,"%",{"$f":"IF(ISERROR(T18/S18),\"\",T18/S18)","v":""}]
[null,6,null,null,null,7,null,null,null,8,null,null,null,9,null,null,null,10]
[null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings"]
[null,"# Of Games Played",null,null,0,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played"]
[]
[]
[]
[]
[null,{"$f":"IF(COUNT(C22:C26)=0,\"\",COUNT(C22:C26))","v":""},{"$f":"IF(SUM(C22:C26)<=0,\"\",SUM(C22:C26))","v":""},{"$f":"IF(SUM(D22:D26)<=0,\"\",SUM(D22:D26))","v":""},null,{"$f":"IF(COUNT(G22:G26)=0,\"\",COUNT(G22:G26))","v":""},{"$f":"IF(SUM(G22:G26)<=0,\"\",SUM(G22:G26))","v":""},{"$f":"IF(SUM(H22:H26)<=0,\"\",SUM(H22:H26))","v":""},null,{"$f":"IF(COUNT(K22:K26)=0,\"\",COUNT(K22:K26))","v":""},{"$f":"IF(SUM(K22:K26)<=0,\"\",SUM(K22:K26))","v":""},{"$f":"IF(SUM(L22:L26)<=0,\"\",SUM(L22:L26))","v":""},null,{"$f":"IF(COUNT(O22:O26)=0,\"\",COUNT(O22:O26))","v":""},{"$f":"IF(SUM(O22:O26)<=0,\"\",SUM(O22:O26))","v":""},{"$f":"IF(SUM(P22:P26)<=0,\"\",SUM(P22:P26))","v":""},null,{"$f":"IF(COUNT(S22:S26)=0,\"\",COUNT(S22:S26))","v":""},{"$f":"IF(SUM(S22:S26)<=0,\"\",SUM(S22:S26))","v":""},{"$f":"IF(SUM(T22:T26)<=0,\"\",SUM(T22:T26))","v":""}]
[null,null,"%",{"$f":"IF(ISERROR(D27/C27),\"\",D27/C27)","v":""},null,null,"%",{"$f":"IF(ISERROR(H27/G27),\"\",H27/G27)","v":""},null,null,"%",{"$f":"IF(ISERROR(L27/K27),\"\",L27/K27)","v":""},null,null,"%",{"$f":"IF(ISERROR(P27/O27),\"\",P27/O27)","v":""},null,null,"%",{"$f":"IF(ISERROR(T27/S27),\"\",T27/S27)","v":""}]
[null,11,null,null,null,12,null,null,null,13,null,null,null,14,null,null,null,15]
[null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings"]
[null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played"]
[]
[]
[]
[]
[null,{"$f":"IF(COUNT(C31:C35)=0,\"\",COUNT(C31:C35))","v":""},{"$f":"IF(SUM(C31:C35)<=0,\"\",SUM(C31:C35))","v":""},{"$f":"IF(SUM(D31:D35)<=0,\"\",SUM(D31:D35))","v":""},null,{"$f":"IF(COUNT(G31:G35)=0,\"\",COUNT(G31:G35))","v":""},{"$f":"IF(SUM(G31:G35)<=0,\"\",SUM(G31:G35))","v":""},{"$f":"IF(SUM(H31:H35)<=0,\"\",SUM(H31:H35))","v":""},null,{"$f":"IF(COUNT(K31:K35)=0,\"\",COUNT(K31:K35))","v":""},{"$f":"IF(SUM(K31:K35)<=0,\"\",SUM(K31:K35))","v":""},{"$f":"IF(SUM(L31:L35)<=0,\"\",SUM(L31:L35))","v":""},null,{"$f":"IF(COUNT(O31:O35)=0,\"\",COUNT(O31:O35))","v":""},{"$f":"IF(SUM(O31:O35)<=0,\"\",SUM(O31:O35))","v":""},{"$f":"IF(SUM(P31:P35)<=0,\"\",SUM(P31:P35))","v":""},null,{"$f":"IF(COUNT(S31:S35)=0,\"\",COUNT(S31:S35))","v":""},{"$f":"IF(SUM(S31:S35)<=0,\"\",SUM(S31:S35))","v":""},{"$f":"IF(SUM(T31:T35)<=0,\"\",SUM(T31:T35))","v":""}]
[null,null,"%",{"$f":"IF(ISERROR(D36/C36),\"\",D36/C36)","v":""},null,null,"%",{"$f":"IF(ISERROR(H36/G36),\"\",H36/G36)","v":""},null,null,"%",{"$f":"IF(ISERROR(L36/K36),\"\",L36/K36)","v":""},null,null,"%",{"$f":"IF(ISERROR(P36/O36),\"\",P36/O36)","v":""},null,null,"%",{"$f":"IF(ISERROR(T36/S36),\"\",T36/S36)","v":""}]
[]
[null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings",null,null,"Shoes","Rings"]
[null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played",null,null,null,"# Of Games Played"]
[]
[]
[]
[]
[null,{"$f":"IF(COUNT(C40:C44)=0,\"\",COUNT(C40:C44))","v":""},{"$f":"IF(SUM(C40:C44)<=0,\"\",SUM(C40:C44))","v":""},{"$f":"IF(SUM(D40:D44)<=0,\"\",SUM(D40:D44))","v":""},null,{"$f":"IF(COUNT(G40:G44)=0,\"\",COUNT(G40:G44))","v":""},{"$f":"IF(SUM(G40:G44)<=0,\"\",SUM(G40:G44))","v":""},{"$f":"IF(SUM(H40:H44)<=0,\"\",SUM(H40:H44))","v":""},null,{"$f":"IF(COUNT(K40:K44)=0,\"\",COUNT(K40:K44))","v":""},{"$f":"IF(SUM(K40:K44)<=0,\"\",SUM(K40:K44))","v":""},{"$f":"IF(SUM(L40:L44)<=0,\"\",SUM(L40:L44))","v":""},null,{"$f":"IF(COUNT(O40:O44)=0,\"\",COUNT(O40:O44))","v":""},{"$f":"IF(SUM(O40:O44)<=0,\"\",SUM(O40:O44))","v":""},{"$f":"IF(SUM(P40:P44)<=0,\"\",SUM(P40:P44))","v":""},null,{"$f":"IF(COUNT(S40:S44)=0,\"\",COUNT(S40:S44))","v":""},{"$f":"IF(SUM(S40:S44)<=0,\"\",SUM(S40:S44))","v":""},{"$f":"IF(SUM(T40:T44)<=0,\"\",SUM(T40:T44))","v":""}]
[null,null,"%",{"$f":"IF(ISERROR(D45/C45),\"\",D45/C45)","v":""},null,null,"%",{"$f":"IF(ISERROR(H45/G45),\"\",H45/G45)","v":""},null,null,"%",{"$f":"IF(ISERROR(L45/K45),\"\",L45/K45)","v":""},null,null,"%",{"$f":"IF(ISERROR(P45/O45),\"\",P45/O45)","v":""},null,null,"%",{"$f":"IF(ISERROR(T45/S45),\"\",T45/S45)","v":""}]
[null,"Attending Non-Throwers must sign under their name in the empty boxes"]
[null,"This sheet must be legible and filled in completley then checked with the Master Score Sheet !!!!"]
[null,null,"1st Offense 5 match pt. penalty , 2nd Offense 10 match pt. penalty for incomplete or incorrect sheet."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}